# 调用ansys程序命令
#import os
#path = 'D:/test'
#os.chdir(path)

#ansys = r'""D:\Program Files\ANSYS Inc\v170\ansys\bin\winx64\MAPDL.exe"  -g -p ane3fl -dir "C:\Users\10707" -j "file" -s read -l en-us -t -d win32   "'
#os.system(ansys)
########################################################

import xlrd
import math
import xlwt
from collections import Counter
data = []
wb = xlrd.open_workbook('1-canshu220231003-q.xlsx')                                           # 打开预处理后的股道数据
sheet = wb.sheets()[0]
column_data = sheet.col_values(0)
unique_column_data = Counter(column_data)
number_of_unique_column_data = len(unique_column_data)
b = [key for key in unique_column_data.keys()]
c = [value for value in unique_column_data.values()]
a = b[1]
a = 1

unique_column_data = Counter(column_data)
number_of_unique_column_data = len(unique_column_data) - 2
b = [(key, value) for key, value in unique_column_data.items()]